Organisation Structure Interface Table

This extract file interface handles records for each organisation hierarchy node to be added or updated in the CXP Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. database. Each child node record contains the ID of its parent node allowing hierarchies to be described as a series of parent /child relationships. Data loaded via this interface is primarily bound for the ORGANISATION_UNIT and ORGANISATION_UNIT_SNAPSHOT CXP Admin schema tables.

External table name	Schema	Mapped file
org_structure_Interface	Staging	org_structure.dat

Organisation structure interface table fields

Column Heading	Type	Length	Description
EXTERNAL_ORGANISATION_I	VarChar2	40	The Identifier of the organisation to which the organisation unit depicted by the current record belongs.
EXTERNAL_ORGANISATION_UNIT_ID	VarChar2	40	Unique identifier denoting an organisation unit element within a customer's organisation unit hierarchy.
ORGANISATION_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the current organisation unit resides. There is an assumption that EXTERNAL_ORGANISATION_ID values are only unique at the level within the hierarchy indicated. Therefore a level 1 node with an identifier of 'ABC' is considered to be a different node to a level 2 node with identifier 'ABC'.
EXTERNAL_ORG_UNIT_TYPE	VarChar2	40	Denotes the sub type of the current customer hierarchy element, within its level. This value allows the various types of organisation unit to be differentiated from one another for the purposes of icon assignment in tree views and reporting.
EXTERNAL_PARENT_ORG_UNIT_ID	VarChar2	40	dentifier denoting the parent organisation unit of the current organisation unit within the organisation unit hierarchy. Note: Every EXTERNAL_PARENT_ORG_UNIT_ID referenced here must also be represented as an EXTERNAL_ORGANISATION_UNIT_ID on a different record in the 'org_structure.dat' extract file associated with the current extract file set. This effectively means that organisation hierarchies must be shown complete from the Lowest node represented by an 'org_structure.dat' extract file upwards.
PARENT_ORG_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the parent organisation unit resides.
ORG_UNIT_ DEACTIVATION_DATE	Date		Used to differentiate between active and inactive (disconnected/deactivated) organisation units. Active organisation units are those with a NULL deactivation date. Inactive organisation units are those with an actual date value, representing the date of deactivation. Whilst it is generally assumed that once an organisation unit has deactivated, then it will not reactivate, the deactivation date can be reset by passing a NULL value here to remove the deactivation date stored in the database.
ALIAS_1	VarChar2	40	Alternative description or code used to identify the current organisation hierarchy element. Used in displays to help the user more readily identify organisation unit elements.
ALIAS_2	VarChar2	40	Alternative description or code used to identify the current organisation hierarchy element. Used in displays to help the user more readily identify organisation unit elements.